TCustomMSConnection.OpenDatasets Method

Opens several datasets as one batch.

Class

TCustomMSConnection

Syntax

procedure OpenDatasets(const ds: array of TCustomMSDataSet);

Remarks

Call the OpenDatasets method to open several datasets as one batch. This method can significantly increase performance when opening queries through remote connection (e. g. Internet).

When you execute a query through remote connection, a delay occurs. If you open more than one query, the time of the delay increases proportionally to the number of opened queries. The OpenDatasets method puts all SQL queries from the received datasets together and executes them as one package. The received results are redistributed to the original dataset.

Note, that when this operation is performed, each one of the opened datasets should return only one resultset.